Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
InventoryControlDocumentID (PK) | The reference number that uniquely identifies the InventoryControlDocument. | ID_ICD | Identity | integer | |
DestinationBusinessUnitID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN_DST | Identity | integer | BusinessUnit(LO_BSN_UN) |
SourceBusinessUnitID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN_SRC | Identity | integer | BusinessUnit(LO_BSN_UN) |
VendorID (FK) | A unique system assigned identifier for the Vendor. | ID_VN_PCKG | Identity | integer | Vendor(PA_VN) |
CurrencyID (FK) | The unique identifier of the Currency. | ID_CNY | Identity | integer | Currency(CO_CNY) |
CompleteDateTimestamp | The time and date when the processing of the inventory control document was completed. | TS_CMPL | AuditDateTime | datetime | |
DocumentTypeCode | This code identifies the type of InventoryControlDocument. | TY_ICD | Code2 | char(2) | |
CreateDateTimestamp | The time and date when the inventory control document was originally created. | TS_CRT_ICD | AuditDateTime | datetime | |
LastUpdateDate | The date when the inventory control document was last updated by the store. | DC_UPDT_LS_ICD | DateCalendar | date | |
TermsAndConditionsCode | This code denotes the relevant terms and conditions pertaining to this particular inventory control document, eg the supplier must be notified of any shortages within three days. | LU_TRMCD_ICD | Code4 | char(4) | |
ReceivedDifferenceCode | A code to indicate the reason for the difference between the quantity ordered and quantity shipped. This code relates to the UCC code, Shipment/Order Status Code, data element 368. | LU_DF_RCV_ICD | Code2 | char(2) | |
DeferredPaymentDate | The deferred payment date on which the RETIL STORE has to make its payment. Deferred payments are an inducement to retailers to accept certain stock. | DC_PYM_DFR_ICD | DateCalendar | date | |
ExpectedDeliveryDate | The expected delivery date of the shipment, to which this particular inventory control document relates. | DC_DV_EXP_ICD | DateCalendar | date | |
ActualDeliveryDate | The actual delivery date of the shipment, to which this particular inventory control document relates. | DC_DV_ACT_ICD | DateCalendar | date | |
SupplierExpectedShipDate | The expected arrival date of the shipment, to which this particular inventory control document relates. | DC_SPR_EXP_SHP_ICD | DateCalendar | date | |
SupplierActualShipDate | The actual ship date of the shipment, to which this particular inventory control document relates. The actual date of the to which this particular inventory control document relates, is expected to be shipped from the originating company or store. | DC_SPR_ACT_SHP | DateCalendar | date | |
UnitDiscrepancyCount | The discrepancy count between the units recorded on the InventoryControlDocument and the actual units counted. | QU_DSCP_ICD | Quantity | DECIMAL(9,3) | |
OriginatorID | Identifies the point of origin for this inventory control document. An originator may be a program (for automatically generated documents) or a person. | ID_ORGR_ICD | Identity | integer | |
FreightChargeDispositionCode | A code that assigns responsibility for payment of the freight and insurance charges for this inventory control document to the store or other party in the transaction. | DP_CHG_FRGT_ICD | Code4 | char(4) | |
ContractReferenceNumber | The contract against which the delivery has been made. | ID_CNTRT | IdentityAlphaNumeric | varchar(20) | |
SerialFormID | An idenfier for this document, usually preprinted on the form stock prior to being filled out. | ID_SRZ_FRM | IdentityAlphaNumeric | varchar(20) | |
ISOCurrencyCode (FK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | ISO4217-CurrencyType(LU_CNY_ISO_4217) |